
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spConPointsGetByDescription]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spConPointsGetByDescription]
GO

CREATE PROCEDURE spConPointsGetByDescription
	@Description nvarchar(50)
AS

SELECT
	[ConPointID],
	[Description],
	[Goods],
	[IsDisplayed],
	[ContainerLoading],
	[LoadingPort]
FROM
	[ConPoints]
WHERE
	Description = @Description

GO
	

	
